Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

SQL Sorting Memory (-SQLTempBuff)

Use SQL Sorting Memory (-SQLTempBuff) to define the size in K-bytes of the temporary table buffers in main memory cache.

Operating system and syntax	UNIX Windows	-SQLTempBuff value
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
SQL	200000	100	1000	1000

value

Size in K-bytes of the temporary table buffers in main memory cache.

Increasing the value of -SQLTempBuff lessens the amount of IO for temporary tables. Decreasing the value frees memory for other uses.

Note: Each connection allocates one temporary table buffer.